USE [CTEM-DB-v1]
GO
/****** Object:  StoredProcedure [dbo].[Role_GetByMenuID]    Script Date: 10/10/2011 23:01:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		GiangPNT
-- Create date: 10/10/2011
-- Description:	Get employee's information by ID
-- =============================================
CREATE PROCEDURE [dbo].[Role_GetByID]
	@roleID BIGINT
AS
BEGIN
	SELECT	RoleID, RoleName, Description, RightsValue, IsActive
	FROM	Role
	WHERE	RoleID = @roleID
END
